package com.glwan.fixedassetapp.common;

import java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Deprecated
public class ExcelTemplateConstant {


    public static final String[] ASSET_IMPORT_TEMPLATE = {
            "ID",
            "公司代码",
            "会计年度",
            "资产编号",
            "资产名称",
            "成本中心",
            "成本中心名称",
            "资产目录编码",
            "资产目录名称",
            "资产序列号",
            "规格型号",
            "数量",
            "计量单位",
            "存放地点",
            "资产使用情况",
            "使用部门",
            "使用人",
            "责任人",
            "供应商",
            "供应商名称",
            "录入人",
            "录入日期",
            "盘点状态",
            "REASON"
    };
    public static final List<String> ASSET_IMPORT_TEMPLATE_COLUMN_ARRAY = Arrays.asList(
            "ID",
            "CompanyCode",
            "FiscalYear",
            "SerialNumber",
            "AssetName",
            "CostCenter",
            "CostCenterName",
            "AssetCatalogCode",
            "AssetCatalogName",
            "AssetSerialNumber",
            "SpecificationModel",
            "Quantity",
            "MeasurementUnit",
            "PlaceOfPreservation",
            "AssetUsageStatus",
            "UsingDepartment",
            "User",
            "ResponsiblePerson",
            "Supplier",
            "SupplierName",
            "EnteredBy",
            "EntryDate",
            "InventoryStatus",
            "REASON"
    );
    public static final String[] ASSET_IMPORT_TEMPLATE_NEW = {
            "序号",
            "资产编码",
            "资产名称",
            "规格",
            "型号",
            "品牌",
            "序列号",
            "资产类别",
            "单位",
            "数量",
            "税率",
            "购买日期",
            "存放地点",
            "使用部门",
            "使用人",
            "使用状态",
            "备注",
            "盘点状态",
    };
    public static final List<String> ASSET_IMPORT_TEMPLATE_COLUMN_ARRAY_NEW = Arrays.asList(
            "no",
            "assetNumber",
            "assetName",
            "specs",
            "model",
            "brand",
            "serialNumber",
            "assetCategory",
            "unit",
            "quantity",
            "taxRate",
            "purchaseDate",
            "storeLocation",
            "usingDepartment",
            "user",
            "usageStatus",
            "mark",
            "inventoryStatus"
    );


    public static Map<String, String> getDatabaseKeyMapping() {
        Map<String, String> databaseKeys = new HashMap<>();
        for (int i = 0; i < ASSET_IMPORT_TEMPLATE.length; i++) {
            databaseKeys.put(ASSET_IMPORT_TEMPLATE[i], ASSET_IMPORT_TEMPLATE_COLUMN_ARRAY.get(i));
        }
        return databaseKeys;
    }
    public static Map<String, String> getDatabaseKeyMappingNew() {
        Map<String, String> databaseKeys = new HashMap<>();
        for (int i = 0; i < ASSET_IMPORT_TEMPLATE_NEW.length; i++) {
            databaseKeys.put(ASSET_IMPORT_TEMPLATE_NEW[i], ASSET_IMPORT_TEMPLATE_COLUMN_ARRAY_NEW.get(i));
        }
        return databaseKeys;
    }


}
